CREATE PROCEDURE GetFromPersonalByDescNoActivados
@DNI varchar(20)
AS
BEGIN
SELECT *
FROM Personal
WHERE ('%'+DNI+'%' LIKE '%'+@DNI+'%' OR UPPER(Nombre) LIKE upper(+'%'+@DNI+'%')) AND Activacion = 'NO'
END
